TaskTemplate

EntityType | Independent
Logical Entity Name | TaskTemplate
Default Table Name | CmTemplate
Logical Only | NO
Owner | dbo
Definition |
Note |

TaskTemplate Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Code |  | CHAR(8) | NO |
Name |  | VARCHAR(50) | NO |
DefaultDuration |  | INTEGER | NO |
DefaultStaffStatus |  | CHAR(8) | NO |
DefaultTaskStatusId |  | INTEGER | NO |
TaskResultId |  | INTEGER | YES |
cmTemplateAssignToID |  | INTEGER | NO |
StaffId |  | INTEGER | YES |
Message |  | PICTURE | NO |
EventText |  | PICTURE | NO |
TaskTypeId |  | INTEGER | YES |
IsActive |  | BIT | NO |
ModFlag |  | CHAR(1) | NO |
LastModifiedUserId |  | INTEGER | NO |
IsSystemCode |  | BIT | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
TaskTemplateId |  | INTEGER | NO |
CampusGroupId |  | INTEGER | YES |
EmployerContactFlag |  | CHAR(1) | NO |
SendTo |  | CHAR(1) | YES |
StudentContactFlag |  | CHAR(1) | NO |
DefaultText |  | TEXT | YES |
AddressTypeId |  | INTEGER | YES |
IsFollowupRequired |  | BIT | NO |
JobActivityFlag |  | CHAR(1) | NO |
EmployerContactActivityFlag |  | CHAR(1) | NO |
IncidentTypeId |  | INTEGER | YES |
IncidentLocationFlag |  | CHAR(1) | YES |
RowVersion |  | TIMESTAMP/DATE | NO |
TaskCategoryId |  | INTEGER | YES |
AdvisorTypes |  | VARCHAR(50) | YES |
OtherAdvisorTypes |  | VARCHAR(500) | YES |
IsSmsSentAsEmail |  | BIT | NO |
IsCommentsDisplayedToStudent |  | BIT | NO |
OrganizationContactFlag |  | CHAR(1) | NO |
OrganizationContactActivityFlag |  | CHAR(1) | NO |
OrganizationTypeId |  | INTEGER | YES |
EmailSubject |  | VARCHAR(255) | YES |
IsIntegrated |  | BIT | NO |
CRMProcess |  | BIT | NO |
CrmIntegrationEffectiveDate |  | DATETIME | YES |

TaskTemplate Keys

Key Name | Key Type | Keys
CmTemplate_CmTemplateID_U_C_IDX | PrimaryKey | TaskTemplateId
CmTemplate_SyOrganizationTypeID_N_N_IDX | Inversion Entry | OrganizationTypeId
CmTemplate_CmActivityCatID_N_N_IDX | Inversion Entry | TaskCategoryId
CmTemplate_SyAddrTypeID_N_N_IDX | Inversion Entry | AddressTypeId
CmTemplate_Code_U_N_IDX | Unique Constraint | Code

TaskTemplate Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
TaskResult | Non-Identifying | Zero or One to Zero or More |  |  |  | TaskResultId | NO
TaskCategory | Non-Identifying | Zero or One to Zero or More |  |  |  | TaskCategoryId | NO
AddressType | Non-Identifying | Zero or One to Zero or More |  |  |  | AddressTypeId | NO
OrganizationType | Non-Identifying | Zero or One to Zero or More |  |  |  | OrganizationTypeId | NO
IncidentType | Non-Identifying | Zero or One to Zero or More |  |  |  | IncidentTypeId | NO
OrganizationType | Non-Identifying | Zero or One to Zero or More |  |  |  | OrganizationTypeId | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | StaffId | NO
TaskCategory | Non-Identifying | Zero or One to Zero or More |  |  |  | TaskCategoryId | NO
TaskType | Non-Identifying | Zero or One to Zero or More |  |  |  | TaskTypeId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
StudentEnrollmentPeriodTransfer | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentEnrollmentPeriodTransfer | Non-Identifying | One To Zero or More |  |  |  |  | NO
TaskArchive | Non-Identifying | One To Zero or More |  |  |  |  | NO
TaskTemplateDocumentType | Non-Identifying | One To Zero or More |  |  |  |  | NO
TaskTemplateOrganizationType | Non-Identifying | One To Zero or More |  |  |  |  | NO
AutoAwardPaymentPlanSetting | Non-Identifying | One To Zero or More |  |  |  |  | NO
AutoAwardPaymentPlanSetting | Non-Identifying | One To Zero or More |  |  |  |  | NO
AutoAwardPaymentPlanSetting | Non-Identifying | One To Zero or More |  |  |  |  | NO
PostWithdrawalDisbursementConfigurationDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
PostWithdrawalDisbursementConfigurationDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
PostWithdrawalDisbursementConfigurationDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
Campus | Non-Identifying | One To Zero or More |  |  |  |  | NO
Campus | Non-Identifying | One To Zero or More |  |  |  |  | NO
CampusDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
CampusDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
CampusDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
CampusDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
SyServiceExceptionNotificationTemplate | Non-Identifying | One To Zero or More |  |  |  |  | NO
SyServiceRequestNotification | Non-Identifying | One To Zero or More |  |  |  |  | NO
TaskTemplateLetter | Non-Identifying | One To Zero or More |  |  |  |  | NO
Incident | Non-Identifying | One To Zero or More |  |  |  |  | NO
Task | Non-Identifying | One To Zero or More |  |  |  |  | NO
TaskArchive | Non-Identifying | One To Zero or More |  |  |  |  | NO
TaskPolicyDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
TaskTemplateDocumentType | Non-Identifying | One To Zero or More |  |  |  |  | NO
TaskTemplateDocumentTypeAttachment | Non-Identifying | One To Zero or More |  |  |  |  | NO
TaskTemplateLetter | Non-Identifying | One To Zero or More |  |  |  |  | NO
TaskTemplateOrganizationType | Non-Identifying | One To Zero or More |  |  |  |  | NO
TaskTemplateScriptQuestion | Non-Identifying | One To Zero or More |  |  |  |  | NO
TaskTemplateScriptQuestionAnswer | Non-Identifying | One To Zero or More |  |  |  |  | NO
TaskTemplateScriptQuestionAnswerAction | Non-Identifying | One To Zero or More |  |  |  |  | NO
TaskTemplateScriptQuestionAnswerAction | Non-Identifying | One To Zero or More |  |  |  |  | NO

TaskTemplate Check Constraints

Check Constraint Name | CheckConstraint

TaskTemplate Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.TaskTemplate | NO |  |  |
Physical (Microsoft SQL Server) dbo.CmTemplate | NO |  |  |

TaskTemplate Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Incidents
Logical | Tasks
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records
Physical (Microsoft SQL Server) | Career Services

TaskTemplate Data Movement Rules

Name | Type | Rule Text/Value